<?php 
 
 include ("global_files/report_customization.inc"); 
 include ("global_files/tables.inc"); 

 $i=0; 
$columns_array1[$i]["filter_name"]="commercial_id";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(commercial_id)";
$columns_array1[$i]["form_display"]="Commercial id";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="name_of_signatory";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(name_of_signatory)";
$columns_array1[$i]["form_display"]="Name of signatory";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="value";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(value)";
$columns_array1[$i]["form_display"]="Value";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="quantity_type_id";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(quantity_type_id)";
$columns_array1[$i]["form_display"]="Quantity type id";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="no_of_pkgs";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(no_of_pkgs)";
$columns_array1[$i]["form_display"]="No of pkgs";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="marks_and_nos";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(marks_and_nos)";
$columns_array1[$i]["form_display"]="Marks and nos";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="destination";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(destination)";
$columns_array1[$i]["form_display"]="Destination";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="discharge";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(discharge)";
$columns_array1[$i]["form_display"]="Discharge";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="city_name";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(city_name)";
$columns_array1[$i]["form_display"]="City name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="shipment_mode_name";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(shipment_mode_name)";
$columns_array1[$i]["form_display"]="Shipment mode name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="place_of_receipt";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(place_of_receipt)";
$columns_array1[$i]["form_display"]="Place of receipt";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="pre_carriage";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(pre_carriage)";
$columns_array1[$i]["form_display"]="Pre carriage";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="account";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(account)";
$columns_array1[$i]["form_display"]="Account";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="buyer";
$columns_array1[$i]["filter_table_join"]="certificate_of_origin_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(buyer)";
$columns_array1[$i]["form_display"]="Buyer";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$db->query="begin work;";
$db->runQuery();
createNewFilters($columns_array1);
$db->query="commit work;";
$db->runQuery();

?>